/**
 * Copyright 2008 floop.pl
 * Licensed under the Apache License, Version 2.0 (the "License"); 
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 * http://www.apache.org/licenses/LICENSE-2.0 
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 **/
package org.eaicompiler.sqlgen;

import java.util.Iterator;

import org.eaicompiler.model.ScriptDefinition;
import org.eaicompiler.sqlgen.builders.EventaiScriptsSQLBuilder;
import org.eaicompiler.sqlgen.builders.LocalizedTextsSQLBuilder;

/**
 * SQL generator that turns the script definition into SQL queries. 
 * @author floop.pl
 */
public class SqlGenerator {
	private ScriptDefinition script;
	private boolean useDelete;

	public SqlGenerator(ScriptDefinition script) {
		super();
		this.script = script;
		// Should we generate delete statements?
		this.useDelete = true;
	}

	public String getLocalizedTextsSQL()
	{
		StringBuffer sql = new StringBuffer();
		Iterator<Integer> creature = script.getCreatureFor().iterator();
		while(creature.hasNext())
		{
			Integer creatureId = creature.next();
			LocalizedTextsSQLBuilder b = new LocalizedTextsSQLBuilder(script, useDelete, creatureId.intValue());
			sql.append(b.buildSQLForCreature());
		}
		return sql.toString();
	}
	
	public String getEventsTextsSQL()
	{
		StringBuffer sql = new StringBuffer();
		Iterator<Integer> creature = script.getCreatureFor().iterator();
		while(creature.hasNext())
		{
			Integer creatureId = creature.next();
			EventaiScriptsSQLBuilder b = new EventaiScriptsSQLBuilder(script, useDelete, creatureId.intValue());
			sql.append(b.buildSQLForCreature());
		}
		return sql.toString();
	}	
}
